EXCEL 2007 PIVOTTABLES AND PIVOTCHARTS
نویسندگان
چکیده
منابع مشابه
Teaching statistics with Excel 2007 and other spreadsheets
This article considers which activities in teaching statistics may be suitable candidates for the application of spreadsheets, and whether spreadsheets in general and Excel 2007 in particular are suitable for these tasks. © 2008 Elsevier B.V. All rights reserved.
متن کاملThe accuracy of statistical distributions in Microsoft® Excel 2007
We provide an assessment of the statistical distributions in Microsoft r © Excel versions 97 through 2007 along with two competing spreadsheet programs, namely Gnumeric 1.7.11 and OpenOffice.org Calc 2.3.0. We find that the accuracy of various statistical functions in Excel 2007 range from unacceptably bad to acceptable but significantly inferior in comparison to alternative implementations. In...
متن کاملOn the accuracy of statistical procedures in Microsoft Excel 2007
Excel 2007, like its predecessors, fails a standard set of intermediate-level accuracy tests in three areas: statistical distributions, random number generation, and estimation. Additional errors in specific Excel procedures are discussed.Microsoft’s continuing inability to correctly fix errors is discussed. No statistical procedure in Excel should be used until Microsoft documents that the pro...
متن کاملIntroduction:Why Simulation and Excel?
This book is meant to be read and used by professors and economists. It assumes familiarity with economic theory and data analysis, so it will not make sense to a student or beginner. It is a manual for utilizing teaching materials that are available on the Web at http://www.depauw.edu/learn/ macroexcel. It is assumed that the professor has a favorite textbook or readings that neither this book...
متن کاملIt's easy to produce chartjunk using Microsoft®Excel 2007 but hard to make good graphs
The purpose of default settings in a graphic tool is tomake it easy to produce good graphics that accord with the principles of statistical graphics, e.g., [Tufte, E.R., 1990. Envisioning Information. Graphics Press, Cheshire, Conn, Tufte, E.R., 1997. Visual Explanations: Images and Quantities, Evidence and Narrative, 2nd Edition. Graphics Press, Cheshire, Conn, Cleveland, W.S., 1993. Visualizi...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Journal of Technology and Information
سال: 2010
ISSN: 1803-537X,1803-6805
DOI: 10.5507/jtie.2010.016